ADO.NET Dataspecifieke klassen
Home

ADO.NET Dataspecifieke klassen

ADO.NET Dataspecifieke klassen

Bijvoorbeeld, de SqlConnection en de OleDbConnection klasse zijn afgeleid van de klasse DbConnection, die op zijn beurt de IDbConnection-interface implementeert. De volgende tabel bevat de database specifieke klassen:

Klassen

Beschrijving

SqlCommand, OleDbCommand, and ODBCCommand

Used as wrappers for SQL statements or stored procedure calls.

SqlCommandBuilder, OleDbCommandBuilder, and ODBCCommandBuilder

Used to generate SQL commands (such as INSERT, UPDATE, and DELETE statements) from a SELECT statement.

SqlConnection, OleDbConnection, and ODBCConnection

Used to connect to the database.

SqlDataAdapter, OleDbDataAdapter, and ODBCDataAdapter

Used to hold select, insert, update, and delete

commands, which are then used to populate a DataSet and update the database.

SqlDataReader, OleDbDataReader, and ODBCDataReader

Used as a forward-only connected data reader.

SqlParameter, OleDbParameter, and ODBCParameter

Used to defi ne a parameter to a stored procedure.

SqlTransaction, OleDbTransaction, and ODBCTransaction

Used for a database transaction, wrapped in an object.

JI
2017-01-21 16:24:48